Overview

Dataset statistics

Number of variables20
Number of observations10000
Missing cells55130
Missing cells (%)27.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.3 MiB
Average record size in memory453.1 B

Variable types

NUM9
CAT6
BOOL5

Reproduction

Analysis started2020-07-18 07:41:38.125845
Analysis finished2020-07-18 07:42:12.125508
Duration34 seconds
Versionpandas-profiling v2.7.1
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml
person has a high cardinality: 7144 distinct values High cardinality
reward is highly correlated with reward_expectedHigh correlation
reward_expected is highly correlated with rewardHigh correlation
reward_expected is highly correlated with offer_idHigh correlation
offer_id is highly correlated with reward_expected and 1 other fieldsHigh correlation
offer_type is highly correlated with offer_idHigh correlation
offer_id has 4539 (45.4%) missing values Missing
amount has 5461 (54.6%) missing values Missing
reward_expected has 8818 (88.2%) missing values Missing
reward has 4539 (45.4%) missing values Missing
difficulty has 4539 (45.4%) missing values Missing
duration has 4539 (45.4%) missing values Missing
offer_type has 4539 (45.4%) missing values Missing
web has 4539 (45.4%) missing values Missing
email has 4539 (45.4%) missing values Missing
mobile has 4539 (45.4%) missing values Missing
social has 4539 (45.4%) missing values Missing
person is uniformly distributed Uniform
df_index has unique values Unique
time has 459 (4.6%) zeros Zeros
reward has 884 (8.8%) zeros Zeros
difficulty has 884 (8.8%) zeros Zeros

Variables

df_index
Real number (ℝ≥0)

UNIQUE
Distinct count10000
Unique (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean136634.7216
Minimum13
Maximum272744
Zeros0
Zeros (%)0.0%
Memory size78.2 KiB

Quantile statistics

Minimum13
5-th percentile13679.45
Q168710
median135995.5
Q3204147.75
95-th percentile258374.25
Maximum272744
Range272731
Interquartile range (IQR)135437.75

Descriptive statistics

Standard deviation78276.22095
Coefficient of variation (CV)0.5728867453
Kurtosis-1.187308503
Mean136634.7216
Median Absolute Deviation (MAD)67725
Skewness-0.004384831313
Sum1366347216
Variance6127166767
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
179270 1 < 0.1%
 
204177 1 < 0.1%
 
101182 1 < 0.1%
 
56729 1 < 0.1%
 
152984 1 < 0.1%
 
93591 1 < 0.1%
 
54083 1 < 0.1%
 
46484 1 < 0.1%
 
34194 1 < 0.1%
 
87440 1 < 0.1%
 
Other values (9990) 9990 99.9%
 
ValueCountFrequency (%) 
13 1 < 0.1%
 
46 1 < 0.1%
 
134 1 < 0.1%
 
163 1 < 0.1%
 
193 1 < 0.1%
 
ValueCountFrequency (%) 
272744 1 < 0.1%
 
272720 1 < 0.1%
 
272718 1 < 0.1%
 
272683 1 < 0.1%
 
272641 1 < 0.1%
 

person
Categorical

HIGH CARDINALITY
UNIFORM
Distinct count7144
Unique (%)71.4%
Missing0
Missing (%)0.0%
Memory size78.2 KiB
99d0d659823e4fe5a2b9837140fbcc64
 
7
a3d2267a2d1f4eaabd6869c07b03cdf6
 
6
83998670898c4604af38d23e74e52269
 
6
aba68a20aa8a42acbe25ebcf0800414b
 
6
60ce7058fd174a128b48371bd1dbd61b
 
5
Other values (7139)
9970
ValueCountFrequency (%) 
99d0d659823e4fe5a2b9837140fbcc64 7 0.1%
 
a3d2267a2d1f4eaabd6869c07b03cdf6 6 0.1%
 
83998670898c4604af38d23e74e52269 6 0.1%
 
aba68a20aa8a42acbe25ebcf0800414b 6 0.1%
 
60ce7058fd174a128b48371bd1dbd61b 5 0.1%
 
5af71c1246834a02b6d671e3b93f8695 5 0.1%
 
8b6427bb8a2a423f92aeb27e22345449 5 0.1%
 
79d9d4f86aca4bed9290350fb43817c2 5 0.1%
 
3dfb16c7592048699d72aba5307fc67d 5 0.1%
 
1a79f623402a4e53908e254531e04f26 5 0.1%
 
Other values (7134) 9945 99.5%
 

Length

Max length32
Mean length32
Min length32
ValueCountFrequency (%) 
Decimal_Number 10 62.5%
 
Lowercase_Letter 6 37.5%
 
ValueCountFrequency (%) 
Common 10 62.5%
 
Latin 6 37.5%
 
ValueCountFrequency (%) 
ASCII 16 100.0%
 

event
Categorical

Distinct count4
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size78.2 KiB
transaction
4539
offer received
2393
offer viewed
1886
offer completed
1182
ValueCountFrequency (%) 
transaction 4539 45.4%
 
offer received 2393 23.9%
 
offer viewed 1886 18.9%
 
offer completed 1182 11.8%
 

Length

Max length15
Mean length12.3793
Min length11
ValueCountFrequency (%) 
Lowercase_Letter 16 94.1%
 
Space_Separator 1 5.9%
 
ValueCountFrequency (%) 
Latin 16 94.1%
 
Common 1 5.9%
 
ValueCountFrequency (%) 
ASCII 17 100.0%
 

time
Real number (ℝ≥0)

ZEROS
Distinct count120
Unique (%)1.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean365.13
Minimum0
Maximum714
Zeros459
Zeros (%)4.6%
Memory size78.2 KiB

Quantile statistics

Minimum0
5-th percentile6
Q1186
median408
Q3528
95-th percentile648
Maximum714
Range714
Interquartile range (IQR)342

Descriptive statistics

Standard deviation200.1453815
Coefficient of variation (CV)0.5481482799
Kurtosis-1.03883509
Mean365.13
Median Absolute Deviation (MAD)168
Skewness-0.30449619
Sum3651300
Variance40058.17372
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
408 589 5.9%
 
504 554 5.5%
 
576 546 5.5%
 
168 499 5.0%
 
336 482 4.8%
 
0 459 4.6%
 
516 116 1.2%
 
582 115 1.1%
 
510 110 1.1%
 
594 107 1.1%
 
Other values (110) 6423 64.2%
 
ValueCountFrequency (%) 
0 459 4.6%
 
6 82 0.8%
 
12 69 0.7%
 
18 75 0.8%
 
24 67 0.7%
 
ValueCountFrequency (%) 
714 32 0.3%
 
708 35 0.4%
 
702 37 0.4%
 
696 43 0.4%
 
690 28 0.3%
 

offer_id
Categorical

HIGH CORRELATION
MISSING
Distinct count10
Unique (%)0.2%
Missing4539
Missing (%)45.4%
Memory size78.2 KiB
2298d6c36e964ae4a3e7e9706d1fb8c2
645
f19421c1d4aa40978ebb69ca19b0e20d
634
fafdcd668e3743c1bb461111dcafc2a4
615
ae264e3637204a6fb9bb56bc8210ddfd
608
4d5c57ea9a6940dd891ad53e9dbe8da0
555
Other values (5)
2404
ValueCountFrequency (%) 
2298d6c36e964ae4a3e7e9706d1fb8c2 645 6.5%
 
f19421c1d4aa40978ebb69ca19b0e20d 634 6.3%
 
fafdcd668e3743c1bb461111dcafc2a4 615 6.2%
 
ae264e3637204a6fb9bb56bc8210ddfd 608 6.1%
 
4d5c57ea9a6940dd891ad53e9dbe8da0 555 5.5%
 
2906b810c7d4411798c6938adc9daaa5 529 5.3%
 
9b98b8c7a33c4b65b9aebfe6a799e6d9 524 5.2%
 
5a8bc65990b245e5a138643cd4eb9837 478 4.8%
 
0b1e1539f2cc45b7b9fa7c272da2e1d7 467 4.7%
 
3f207df678b143eea3cee63160fa8bed 406 4.1%
 
(Missing) 4539 45.4%
 

Length

Max length32
Mean length18.8369
Min length3
ValueCountFrequency (%) 
Decimal_Number 10 58.8%
 
Lowercase_Letter 7 41.2%
 
ValueCountFrequency (%) 
Common 10 58.8%
 
Latin 7 41.2%
 
ValueCountFrequency (%) 
ASCII 17 100.0%
 

amount
Real number (ℝ≥0)

MISSING
Distinct count2303
Unique (%)50.7%
Missing5461
Missing (%)54.6%
Infinite0
Infinite (%)0.0%
Mean13.682203128442389
Minimum0.05
Maximum943.33
Zeros0
Zeros (%)0.0%
Memory size78.2 KiB

Quantile statistics

Minimum0.05
5-th percentile0.85
Q13.47
median10.64
Q318.655
95-th percentile29.638
Maximum943.33
Range943.28
Interquartile range (IQR)15.185

Descriptive statistics

Standard deviation31.44431525
Coefficient of variation (CV)2.298190939
Kurtosis425.8318363
Mean13.68220313
Median Absolute Deviation (MAD)7.46
Skewness18.79678142
Sum62103.52
Variance988.7449617
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2.18 10 0.1%
 
1.73 10 0.1%
 
1.83 9 0.1%
 
1.24 9 0.1%
 
1.35 8 0.1%
 
1.08 8 0.1%
 
1.76 7 0.1%
 
14.36 7 0.1%
 
8.98 7 0.1%
 
1.61 7 0.1%
 
Other values (2293) 4457 44.6%
 
(Missing) 5461 54.6%
 
ValueCountFrequency (%) 
0.05 3 < 0.1%
 
0.07 3 < 0.1%
 
0.08 3 < 0.1%
 
0.09 1 < 0.1%
 
0.1 2 < 0.1%
 
ValueCountFrequency (%) 
943.33 1 < 0.1%
 
779.29 1 < 0.1%
 
747.74 1 < 0.1%
 
644.85 1 < 0.1%
 
632.31 1 < 0.1%
 

reward_expected
Categorical

HIGH CORRELATION
HIGH CORRELATION
MISSING
Distinct count4
Unique (%)0.3%
Missing8818
Missing (%)88.2%
Memory size78.2 KiB
5
452
2
321
10
251
3
158
ValueCountFrequency (%) 
5 452 4.5%
 
2 321 3.2%
 
10 251 2.5%
 
3 158 1.6%
 
(Missing) 8818 88.2%
 

Length

Max length4
Mean length3.0251
Min length3
ValueCountFrequency (%) 
Decimal_Number 5 62.5%
 
Lowercase_Letter 2 25.0%
 
Other_Punctuation 1 12.5%
 
ValueCountFrequency (%) 
Common 6 75.0%
 
Latin 2 25.0%
 
ValueCountFrequency (%) 
ASCII 8 100.0%
 

gender
Categorical

Distinct count3
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size78.2 KiB
M
5668
F
4176
O
 
156
ValueCountFrequency (%) 
M 5668 56.7%
 
F 4176 41.8%
 
O 156 1.6%
 

Length

Max length1
Mean length1
Min length1
ValueCountFrequency (%) 
Uppercase_Letter 3 100.0%
 
ValueCountFrequency (%) 
Latin 3 100.0%
 
ValueCountFrequency (%) 
ASCII 3 100.0%
 

age
Real number (ℝ≥0)

Distinct count84
Unique (%)0.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean53.6093
Minimum18
Maximum101
Zeros0
Zeros (%)0.0%
Memory size78.2 KiB

Quantile statistics

Minimum18
5-th percentile23
Q141
median54
Q366
95-th percentile82
Maximum101
Range83
Interquartile range (IQR)25

Descriptive statistics

Standard deviation17.48448524
Coefficient of variation (CV)0.3261464941
Kurtosis-0.564895089
Mean53.6093
Median Absolute Deviation (MAD)12
Skewness-0.04294424373
Sum536093
Variance305.7072242
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
58 274 2.7%
 
53 249 2.5%
 
59 248 2.5%
 
54 243 2.4%
 
51 241 2.4%
 
52 238 2.4%
 
56 237 2.4%
 
57 235 2.4%
 
49 229 2.3%
 
64 224 2.2%
 
Other values (74) 7582 75.8%
 
ValueCountFrequency (%) 
18 49 0.5%
 
19 102 1.0%
 
20 85 0.9%
 
21 87 0.9%
 
22 119 1.2%
 
ValueCountFrequency (%) 
101 4 < 0.1%
 
100 4 < 0.1%
 
99 2 < 0.1%
 
98 2 < 0.1%
 
97 6 0.1%
 

income
Real number (ℝ≥0)

Distinct count91
Unique (%)0.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean64118.8
Minimum30000.0
Maximum120000.0
Zeros0
Zeros (%)0.0%
Memory size78.2 KiB

Quantile statistics

Minimum30000
5-th percentile33000
Q148000
median62000
Q377000
95-th percentile103000
Maximum120000
Range90000
Interquartile range (IQR)29000

Descriptive statistics

Standard deviation21220.9076
Coefficient of variation (CV)0.3309623324
Kurtosis-0.4470723483
Mean64118.8
Median Absolute Deviation (MAD)15000
Skewness0.4697450794
Sum641188000
Variance450326919.3
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
73000 226 2.3%
 
70000 209 2.1%
 
56000 207 2.1%
 
52000 202 2.0%
 
53000 199 2.0%
 
60000 198 2.0%
 
55000 197 2.0%
 
57000 197 2.0%
 
61000 197 2.0%
 
54000 196 2.0%
 
Other values (81) 7972 79.7%
 
ValueCountFrequency (%) 
30000 63 0.6%
 
31000 138 1.4%
 
32000 144 1.4%
 
33000 174 1.7%
 
34000 151 1.5%
 
ValueCountFrequency (%) 
120000 8 0.1%
 
119000 30 0.3%
 
118000 32 0.3%
 
117000 29 0.3%
 
116000 32 0.3%
 

days_since_became_member
Real number (ℝ≥0)

Distinct count1559
Unique (%)15.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean589.0626
Minimum0
Maximum1822
Zeros7
Zeros (%)0.1%
Memory size78.2 KiB

Quantile statistics

Minimum0
5-th percentile57
Q1247
median479.5
Q3871.25
95-th percentile1499
Maximum1822
Range1822
Interquartile range (IQR)624.25

Descriptive statistics

Standard deviation431.2562402
Coefficient of variation (CV)0.7321059598
Kurtosis0.007676090412
Mean589.0626
Median Absolute Deviation (MAD)282.5
Skewness0.8414979558
Sum5890626
Variance185981.9447
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
330 28 0.3%
 
226 28 0.3%
 
341 27 0.3%
 
292 26 0.3%
 
303 26 0.3%
 
41 26 0.3%
 
349 26 0.3%
 
198 25 0.2%
 
343 24 0.2%
 
353 23 0.2%
 
Other values (1549) 9741 97.4%
 
ValueCountFrequency (%) 
0 7 0.1%
 
1 1 < 0.1%
 
2 7 0.1%
 
3 5 0.1%
 
4 12 0.1%
 
ValueCountFrequency (%) 
1822 2 < 0.1%
 
1820 1 < 0.1%
 
1819 1 < 0.1%
 
1818 3 < 0.1%
 
1817 3 < 0.1%
 
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size39.2 KiB
1
5908
0
4092
ValueCountFrequency (%) 
1 5908 59.1%
 
0 4092 40.9%
 

reward
Real number (ℝ≥0)

HIGH CORRELATION
MISSING
ZEROS
Distinct count5
Unique (%)0.1%
Missing4539
Missing (%)45.4%
Infinite0
Infinite (%)0.0%
Mean4.390770921076726
Minimum0.0
Maximum10.0
Zeros884
Zeros (%)8.8%
Memory size78.2 KiB

Quantile statistics

Minimum0
5-th percentile0
Q12
median5
Q35
95-th percentile10
Maximum10
Range10
Interquartile range (IQR)3

Descriptive statistics

Standard deviation3.370419014
Coefficient of variation (CV)0.7676144064
Kurtosis-0.8421199191
Mean4.390770921
Median Absolute Deviation (MAD)3
Skewness0.5427676456
Sum23978
Variance11.35972433
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
5 1625 16.2%
 
10 1163 11.6%
 
2 1144 11.4%
 
0 884 8.8%
 
3 645 6.5%
 
(Missing) 4539 45.4%
 
ValueCountFrequency (%) 
0 884 8.8%
 
2 1144 11.4%
 
3 645 6.5%
 
5 1625 16.2%
 
10 1163 11.6%
 
ValueCountFrequency (%) 
10 1163 11.6%
 
5 1625 16.2%
 
3 645 6.5%
 
2 1144 11.4%
 
0 884 8.8%
 

difficulty
Real number (ℝ≥0)

MISSING
ZEROS
Distinct count5
Unique (%)0.1%
Missing4539
Missing (%)45.4%
Infinite0
Infinite (%)0.0%
Mean7.821827504120124
Minimum0.0
Maximum20.0
Zeros884
Zeros (%)8.8%
Memory size78.2 KiB

Quantile statistics

Minimum0
5-th percentile0
Q15
median10
Q310
95-th percentile20
Maximum20
Range20
Interquartile range (IQR)5

Descriptive statistics

Standard deviation5.134556455
Coefficient of variation (CV)0.6564394897
Kurtosis0.6140649377
Mean7.821827504
Median Absolute Deviation (MAD)3
Skewness0.5656070118
Sum42715
Variance26.36366999
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10 2307 23.1%
 
5 1158 11.6%
 
0 884 8.8%
 
7 645 6.5%
 
20 467 4.7%
 
(Missing) 4539 45.4%
 
ValueCountFrequency (%) 
0 884 8.8%
 
5 1158 11.6%
 
7 645 6.5%
 
10 2307 23.1%
 
20 467 4.7%
 
ValueCountFrequency (%) 
20 467 4.7%
 
10 2307 23.1%
 
7 645 6.5%
 
5 1158 11.6%
 
0 884 8.8%
 

duration
Real number (ℝ≥0)

MISSING
Distinct count5
Unique (%)0.1%
Missing4539
Missing (%)45.4%
Infinite0
Infinite (%)0.0%
Mean158.05896355978757
Minimum72.0
Maximum240.0
Zeros0
Zeros (%)0.0%
Memory size78.2 KiB

Quantile statistics

Minimum72
5-th percentile72
Q1120
median168
Q3168
95-th percentile240
Maximum240
Range168
Interquartile range (IQR)48

Descriptive statistics

Standard deviation51.21029153
Coefficient of variation (CV)0.3239948585
Kurtosis-0.7745756285
Mean158.0589636
Median Absolute Deviation (MAD)48
Skewness0.177781946
Sum863160
Variance2622.493959
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
168 2306 23.1%
 
120 1189 11.9%
 
240 1082 10.8%
 
72 478 4.8%
 
96 406 4.1%
 
(Missing) 4539 45.4%
 
ValueCountFrequency (%) 
72 478 4.8%
 
96 406 4.1%
 
120 1189 11.9%
 
168 2306 23.1%
 
240 1082 10.8%
 
ValueCountFrequency (%) 
240 1082 10.8%
 
168 2306 23.1%
 
120 1189 11.9%
 
96 406 4.1%
 
72 478 4.8%
 

offer_type
Categorical

HIGH CORRELATION
MISSING
Distinct count3
Unique (%)0.1%
Missing4539
Missing (%)45.4%
Memory size78.2 KiB
bogo
2321
discount
2256
informational
884
ValueCountFrequency (%) 
bogo 2321 23.2%
 
discount 2256 22.6%
 
informational 884 8.8%
 
(Missing) 4539 45.4%
 

Length

Max length13
Mean length5.2441
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 15 100.0%
 
ValueCountFrequency (%) 
Latin 15 100.0%
 
ValueCountFrequency (%) 
ASCII 15 100.0%
 

web
Boolean

MISSING
Distinct count2
Unique (%)< 0.1%
Missing4539
Missing (%)45.4%
Memory size78.2 KiB
1
4375
0
1086
(Missing)
4539
ValueCountFrequency (%) 
1 4375 43.8%
 
0 1086 10.9%
 
(Missing) 4539 45.4%
 

email
Boolean

MISSING
Distinct count1
Unique (%)< 0.1%
Missing4539
Missing (%)45.4%
Memory size78.2 KiB
1
5461
(Missing)
4539
ValueCountFrequency (%) 
1 5461 54.6%
 
(Missing) 4539 45.4%
 

mobile
Boolean

MISSING
Distinct count2
Unique (%)< 0.1%
Missing4539
Missing (%)45.4%
Memory size78.2 KiB
1
4994
0
 
467
(Missing)
4539
ValueCountFrequency (%) 
1 4994 49.9%
 
0 467 4.7%
 
(Missing) 4539 45.4%
 

social
Boolean

MISSING
Distinct count2
Unique (%)< 0.1%
Missing4539
Missing (%)45.4%
Memory size78.2 KiB
1
3535
0
1926
(Missing)
4539
ValueCountFrequency (%) 
1 3535 35.4%
 
0 1926 19.3%
 
(Missing) 4539 45.4%
 

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Missing values

Sample

First rows

df_indexpersoneventtimeoffer_idamountreward_expectedgenderageincomedays_since_became_memberprofile_grouprewarddifficultydurationoffer_typewebemailmobilesocial
0182824a4f3350b08934d41a80e526317842b40offer received504f19421c1d4aa40978ebb69ca19b0e20dNaNNaNM4031000.0133315.05.0120.0bogo1.01.01.01.0
1179320fc05227412c64551b11d24e6a07332c1transaction516NaN5.83NaNM4853000.03181NaNNaNNaNNaNNaNNaNNaNNaN
2184377e744b0bba57b4eca9247d37aa2bc932boffer received1682298d6c36e964ae4a3e7e9706d1fb8c2NaNNaNM52106000.023203.07.0168.0discount1.01.01.01.0
32169309ed20a4ecdf94cc99d52f6fd6a07b363offer viewed438ae264e3637204a6fb9bb56bc8210ddfdNaNNaNF2255000.0766110.010.0168.0bogo0.01.01.01.0
4158787ef8f68ebd37f4560ae141cb13317ef06offer received576ae264e3637204a6fb9bb56bc8210ddfdNaNNaNF3340000.0358110.010.0168.0bogo0.01.01.01.0
52372788296312262cd4cc19872e53ad1e10345transaction684NaN3.14NaNM4447000.03971NaNNaNNaNNaNNaNNaNNaNNaN
622368408eb126ad33f447ca3ad076482445c05transaction228NaN7.96NaNM3057000.010181NaNNaNNaNNaNNaNNaNNaNNaN
7790682d0884ac790148f3a57e97a84eb3d302transaction324NaN9.62NaNM3441000.0661NaNNaNNaNNaNNaNNaNNaNNaN
8174117dcba56d7e54546f095f1e774662e60batransaction204NaN5.79NaNM5640000.011571NaNNaNNaNNaNNaNNaNNaNNaN
91879295a1fba0d6d0e4cb183abc82b4ed586dfoffer received03f207df678b143eea3cee63160fa8bedNaNNaNM5733000.055610.00.096.0informational1.01.01.00.0

Last rows

df_indexpersoneventtimeoffer_idamountreward_expectedgenderageincomedays_since_became_memberprofile_grouprewarddifficultydurationoffer_typewebemailmobilesocial
999021964004c66db4925042a5bb103fec87225370transaction564NaN33.44NaNM6799000.03580NaNNaNNaNNaNNaNNaNNaNNaN
9991754082b538cb81add42819dd88b12c42b023foffer viewed528f19421c1d4aa40978ebb69ca19b0e20dNaNNaNF5978000.072205.05.0120.0bogo1.01.01.01.0
9992264011f5d31009d87f411091be6b7d008564cftransaction390NaN3.10NaNF4460000.02751NaNNaNNaNNaNNaNNaNNaNNaN
999335441f2acd6b2a94a48efbcd6437406eb67b9offer received0fafdcd668e3743c1bb461111dcafc2a4NaNNaNF5090000.032202.010.0240.0discount1.01.01.01.0
9994240793e5f9566e11e740f5b61d9ca8802e13b8transaction534NaN5.67NaNM4859000.07271NaNNaNNaNNaNNaNNaNNaNNaN
999514451897681d53482d422f84214bf4e0a77b60offer viewed5044d5c57ea9a6940dd891ad53e9dbe8da0NaNNaNM4752000.0679110.010.0120.0bogo1.01.01.01.0
99962120376fb9bdf5ad7e43eea5133d3621cd1f4doffer viewed5162298d6c36e964ae4a3e7e9706d1fb8c2NaNNaNM2033000.0128113.07.0168.0discount1.01.01.01.0
99971544830750f076ecc945a99bcec8c00d1291e9offer viewed4324d5c57ea9a6940dd891ad53e9dbe8da0NaNNaNF6073000.0666010.010.0120.0bogo1.01.01.01.0
99981188366cbc092fb84a437f9a248420129ca1f2offer viewed3429b98b8c7a33c4b65b9aebfe6a799e6d9NaNNaNF5063000.04015.05.0168.0bogo1.01.01.00.0
99997270918cc6dbe8e124c20b7bc93c39e854cddoffer viewed4140b1e1539f2cc45b7b9fa7c272da2e1d7NaNNaNM6162000.034815.020.0240.0discount1.01.00.00.0